Model Table PROJECT WORK BREAKDOWN STRUCTURE
Attributes
| Attribute | Description (where applicable) |
| Company | Represents the Company connected to the project |
| Description | Represents the description of the ID column |
| ID | Id for a Project activity, Sub project or Project |
| Node Type | Represents the node type: “PROJECT”, “SUB PROJECT” or “ACTIVITY” |
| Project Id | Represents the Id for the project |
| Symbol n Description | # symbol added as prefix to the description for all rows with node type SUB PROJECT, all other rows have same value as in Description column. |
| Hierarchy | Level |
| Work Breakdown Structure | |
| WBS01 |
| WBS02 |
| WBS03 |
| WBS04 |
| WBS05 |
| WBS06 |
| WBS07 |
| WBS08 |
| WBS09 |
| WBS10 |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| PROJECT WORK BREAKDOWN STRUCTURE | DIM_PROJ_WORK_BREAKDOWN_STRUCT_TM | DIM_PROJ_WORK_BREAKDOWN_STRUCT_BI | DIM_PROJ_WORK_BREAKDOWN_STRUCT | On Line |